#ifndef OEEXCELREADER_H
#define OEEXCELREADER_H

#include "auditxls_global.h"

#include <QString>


class OEExcelReaderPrivate;

class AUDITXLSSHARED_EXPORT OEExcelReader
{
public:
    OEExcelReader(QString _fileName);
    ~OEExcelReader();

    // 工作簿
    int createWorkbooks(void);

    int load(QString _fileName);

    // 工作表
    int selectSheet(int sheetIndex);

    //获取工作表数量
    int getSheetsCount();

    //获取工作表名称
    QString getSheetName(int sheetIndex);

    //获取工作表单元格内容
    double getCellDoubleValue(int row, int column);
    QString getCellValue(int row, int column);

    //获取单元表行数
    int getUsedRowsCount();

    //获取单元表列数
    int getUsedColsCount();

    //关闭工作簿
    void closeWorkBook();

private:

    OEExcelReaderPrivate * const d_ptr;

    Q_DECLARE_PRIVATE(OEExcelReader)
    Q_DISABLE_COPY(OEExcelReader)
};

#endif // OEEXCELREADER_H
